<?php
//======================================================================================
// Function: Connect to MSSQL DB
//======================================================================================
// $serverName = "JJ-HOME\MSSQL_1";
// $connectionInfo = array( "Database"=>"reeft_db", "UID"=>"sa", "PWD"=>"costello" );
// $conn = sqlsrv_connect( $serverName, $connectionInfo);
// if( $conn === false ) {
// die( print_r( sqlsrv_errors(), true));
// }
$server = "JJ-HOME\MSSQL_1";
$user = "sa";
$pwd = "costello";
$database = "reeft_db";
try {
$conn = new PDO( "sqlsrv:Server=$server;Database=$database", $user, $pwd );
} catch ( Exception $e ) {
die( print_r( $e->getMessage() ) );
}
?>